This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Some basic maths. Order of calculation is:
Brackets
Operands
Division
Multiplication
Addition
Subtraction
Hence - BODMAS.
There are two errors in your final formula "@IsNumber(DateNow-DueDate/864000)"
Firstly, the bit inside the bracket is trying to divide DueDate by 86400, and then subtract the result of that from DateNow. That's why you were getting your "number expected" error.
What you meant was (DateNow-DueDate)/86400
The second error is using @IsNumber. That returns @True or @False, which in a number field equate to 1 and 0 respectively. your formula in tnside the brackets produced an error, not a number, so @IsNumber was false, so you got a zero.
So, just change your formula for DaysOS to (DateNow-DueDate)/86400 and your sorted. Ideally, you should add a check to make sure that the other fields exist, so that you don't get an error if one of them doesn't. Also, you could just use (@Now-DueDate)/86400 and delete the DateNow field.
Hope this helps,
Phil
Feedback response number WEBB95LD6S created by ~Justin Chugeromanli on 03/08/2013
BODMAS
Return to top
. . BODMAS (~Justin Chugero... 8.Mar.13) 
